package com.yun.zf.admin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yun.zf.common.admin.model.house.es.HouseInfoEs;
import com.yun.zf.common.app.domain.ZfHouseInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ZfHouseInfoMapper extends BaseMapper<ZfHouseInfo> {

    @Select("<script>" +
            " SELECT hi.fixtures,hi.fixtures_year,hi.tags,hi.is_recommend from zf_house_info hi  " +
            "where   hi.basic_id=#{houseId} and hi.city_code=#{cityCode} and hi.province_code=#{provCode}" +
            "</script>")
    HouseInfoEs infoToEs(Long houseId, Long provCode, Long cityCode);
}
